Written by the team who brought you 'Inside Relational Databases'.About the authors:Bill Marklyn, as the Development Manager for the first two major releases of Access, oversaw the entire design and so provides an intimate knowledge of the product.Mark Whitehorn designs and builds databases but is best known for his popular and long running database column in the UK's 'Personal Computer World'."These two authors make a perfect team. Bill Marklyn knows the product inside out and Mark Whitehorn makes the information Accessible." Neil Fawcett, Group Technical Editor, VNU Business Publications"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination -- an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials." Tamsin Todd - Computers & Internet Editor, Amazon.co.ukAbout the book:Accessible Access 2000 assumes that you start with no knowledge of Access or databases and takes you to the point where you can create and use a multi-table database. (For more information, see chapter one).It is written in the highly readable style of the authors' previous book; a style that was much appreciated by readers: "'Inside Relational Databases' is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."Paul McGowan"As a result of ordering and studying your excellent book, 'Inside Relational Databases', it is now required reading for all my students. This e-mail is simply to say thank you for a superb and understandable publication. I've learned a lot from it, and I'm sure my delegates will too."Ian Wilshaw

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders.Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands.Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access.Together they make a great team, illuminating a tricky subject with substance and style.Reviews from the first edition of Inside Relational Databases:"Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own."- Neil Fawcett, Group Technical Editor, VNU Business Publications"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials."- Tamsin Todd, Computer & Internet Editor, Amazon.co.uk"Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."- Paul McGowan

Business Intelligence is an umbrella term, broadly covering the processes involved in extracting valuable business information from the mass of data that exists within a typical enterprise. This book concentrates on two aspects of Business Intelligence, together with the associated IBM products: Data Warehousing - IBM's Visual Warehouse OLAP (On-Line Analytical Processing) - IBM' DB2 OLAP Server If you are a Manager needing an overview of data warehousing and OLAP or a Practitioner needing to understand and use these tools then this book will provide you with all the information you need to make the most of Business Intelligence.

Contents Should we tell you the whole story? Of course, there is an inevitable tension in trying to work like this. For example, in Chapter 16 we talk about referential integrity. There are - sentially six different flavors of referential integrity but Access only s- ports four of them (they are the most important ones however, so you aren't missing out on too much). The problem is this. Should we tell you about the other two? If we do, as an Access user you have every right to be annoyed that we are telling you about a feature you can't use. On the other hand, the six different types that we describe are part of the re- tional world and this book is about that world - we are not trying to teach you how to use Access, we are simply using Access to illustrate the relational model. Ultimately we decided to risk your ire and to describe all of the features of the relational model as we see it, even if Access doesn't support all of them. One advantage of this approach is that if you need to use a different database engine you will almost certainly find the extra information useful. Incidentally, this is not meant to imply that Access is somehow lacking as a relational database engine. The reason we chose it for the first book is that it is such a good example of a relational database tool.

Fast Track to MDX (for SQL Server 2000) Second Edition Mark Whitehorn, Robert Zare and Mosha Pasumansky

OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions).

Fast Track to MDX gives you all the necessary background to let you write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems.

Mark Whitehorn, co-author of the best-selling Inside Relational Databases, is renowned for his knowledge of database systems and the lucidity of his writing. Robert Zare is a Program Manager for Analysis Services at Microsoft: his inspiring talks on MDX sowed the seeds from which this book grew. Mosha Pasumansky was one of the authors of the OLEDB for OLAP specification that defined the MDX language and later he was the developer in charge of the first implementation of MDX in the Microsoft OLAP Services 7.0 product. He is currently the development lead of the Analysis Services engine team.

Second Edition a" It was the clarity, precision and sheer readability of the first edition that made it a best-seller. With that firmly in mind the authors have left the original 18 chaptersintact (apart from minor updates); meaning that the second edition remains the best introduction to MDX for SQL Server 2000 that is available. What they have done is to add three brand new chapters. These introduce the topic of recursion in MDX, walk the reader through the process of creating recursive expressions and finally demonstrate how recursion can be used to effectively solve a series of business problems.

Forward by Amir Netz, Product Unit Manager, SQL Server a" Analysis Services at Microsoft.

A CD containing examples from within the book, and a time-limited version of ProClarity, is included.

Thisiswherewetrytoconvinceyoutobuythisbook, tellyouwhatittriestodo, define a few terms and generally set the scene - all of which makes this more like an introduction than a first chapter, but no-one reads introductions so we called it a chapter. If you have already bought the book and know what it does, feel free to skip to Chapter 2 where the action starts. Whyshouldyoubuythisbook? TherearemanyAccessbooksonthemarket, whyshouldIbuythisone?Doesithavemore informationthananyotherbook? Errr, no, it actually has less than the big reference books you'll also find on the shelf. So, isitverycheap? Well, it isn't as expensive as some but, no, it isn't particularly cheap either. Tobebrutallyfrank, you'renotdoingagreatjobofsellingthistome. Right, time for the hard sell. Bill worked for Microsoft as the Development Manager for the first three versions of Access. I (Mark) work as a database consultant, teach database theory and practice at two Universities and have written the UK Personal ComputerWorld's database column for more than ten years. We met (at a database conference, not unreasonably, given our interests) in the summer before Access 1. 0 was launched and found that we shared similar views on how databases should be designed and built. Since then we have writtenabooktogetherabouttherelationalmodelthatunderliesAccessandall other relational database systems (see below for the inevitable plug). But why write a book about Access itself when there are already so many around? 3 1 Introduction Well, since Bill was in charge of the product's development, it was fair to assume that we had the technical side reasonably well covered.

The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL.

The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently.

A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.